Curse

angrygamer · May 28, 2008, 04:08 PM // 16:08

I used to play a game called America's Army (AA). I know many of you are familiar with it. On the game's home page, there's a little area where they display statistics on various levels of player achievement, expressed as percentages of the game's population: americasarmy.com (check the "User Stats" section, lower left)

For example, you could see that 20% of all AA players, globally, had achieved a marksmanship score of "Expert".

With as many title tracks as there are in GW, I figured they would have something similar at the GW website, but I was unable to locate anything.

I think it would be interesting, at least on a trivial level, to see similar statistics for the GW player base. For example:

- Percentage of players who have obtained Kind of a Big Deal
- Percentage of players who have maxed the Sweet Tooth track
- Percentage of players who have exceeded 1 million XP or 5 million XP, etc

Has anyone seen such information, either at the GW site or elsewhere?

Ctb · May 28, 2008, 04:10 PM // 16:10

I hate that game. I never understood what they were telling me to do in the last training exercise so I always got frustrated and shot the CO.

I'm probably not prime military material...

Drop of Fear · May 28, 2008, 04:15 PM // 16:15

pretty sure a.net has the technology to draw any stats about the players.
after the nightfall preview weekend there was even a chart on guildwars.com about the sunspear title, with names and the exact amount of points people top 20 people had

Zerdikus · May 28, 2008, 04:48 PM // 16:48

what for a technology, the only what you need is a php script how can read the database, more not. the permission to do that, and a website how you can write it. not so much technology or?

but i think a problem if you make this, will be the server down if you make a daily refresh of the website. by so many players i think the server performance will be go dramatically down, if you read the database for all players and interesting stats.

Drop of Fear · May 28, 2008, 05:01 PM // 17:01

with technology i meant more like "technicaly able to do it."
might be fun to do it once in a while tho, before gw2 ^

Esan · May 28, 2008, 05:10 PM // 17:10

Yeah, they should do this. It would be nice to have figures to back up my impression that the number of GWAMMs is now in the thousands.

Zerdikus · May 28, 2008, 05:14 PM // 17:14

can you imagine, there are 3-4 millions player and by only 4 stats for every player
that's are 12-16 millions accesses on the database, more to the normal accesses.

if you like, a massively lag about a intervall for a half to a hour every day,
maybe with login problems, so i think it's not a problem to do this.

Ctb · May 28, 2008, 05:22 PM // 17:22

Quote:

Originally Posted by Zerdikus

if you like, a massively lag about a intervall for a half to a hour, every day. maybe with login problems. so i think it's not a problem to do this.

So don't run the reports using live data. This isn't the sort of reporting that requires or even really benefits from up-to-the-minute accounting anyway.

Zerdikus · May 28, 2008, 05:34 PM // 17:34

Quote:

Originally Posted by Ctb

So don't run the reports using live data. This isn't the sort of reporting that requires or even really benefits from up-to-the-minute accounting anyway.

But you have a time of the day how you must report the data's if you like a daily list. in this time have you a massiv database transfer, that's fact. if you like a weekly list, so have it on one time in the week, etc.

Michael805 · May 28, 2008, 05:39 PM // 17:39

Quote:

Originally Posted by Zerdikus

But you have a time of the day how you must report the data's if you like a daily list. in this time have you a massiv database transfer, that's fact. if you like a weekly list, so have it on one time in the week, etc.

They already pull thousands (actually, tens of thousands) of stats daily for the guild/HB ladders. What the OP is asking is for a percentage of people with a max title. The only time this could cause lag was the first day, really, because it would have to go through millions of accounts to check for maxed titles. Assuming this percentage is updated once daily, they simply would have to run a check to see how many people maxed each title that day... which would be easy since it's already displayed in the chat box anyway, you could just simply draw the information from that and store it in a file until it is needed.

Zerdikus · May 28, 2008, 05:46 PM // 17:46

Quote:

Originally Posted by Michael805

They already pull thousands (actually, tens of thousands) of stats daily for the guild/HB ladders. What the OP is asking is for a percentage of people with a max title. The only time this could cause lag was the first day, really, because it would have to go through millions of accounts to check for maxed titles. Assuming this percentage is updated once daily, they simply would have to run a check to see how many people maxed each title that day... which would be easy since it's already displayed int he chat box anyway, you could just simply draw the information from that and store it in a file until it is needed.

the request must check all players in the database, if the stats have change or not, and this every time if you like to actualy your website. or must read the name of players how have max title, in case it give a seperat table for the titles.

the second case will be faster, in the first case (worst case) you have the 3-4 millions accesses. its a question about the structure of the database.

Ok, for the check how have max the title on this day. you need a seperate table in there you storage the information and the database query how ask this and store this in the table. this query must run in realtime, to collect the information. So you have only a table with playername and max title, thats right. But you have a realtime query how cost processortime and the question is, is the database after this stable.

Michael805 · May 28, 2008, 05:53 PM // 17:53

Quote:

Originally Posted by Zerdikus

the request must check all players in the database, if the stats have change or not. and this every time if you like to actualy your website. or must read the name of players how have max title in case it give a seperat table for the titles.

the second case will be faster, in the first case you have the 3-4 millions accesses.

I have no idea what the bold part is supposed to say.

Look, I'll draw you a picture:

Original count -> count/number of accounts -> daily count of x title achieved (names do not matter, a simple little script that +1'd ever time a certain title was achieved would be plenty) -> Daily + original count + all the other daily counts (or count +1) -> that count/number of accounts = the percentage of people that got that title.

No millions of checks a day. And for the account numbers, they don't even have to be exact or close to exact, they could round it to the nearest 100,000 or so.

Zerdikus · May 28, 2008, 06:12 PM // 18:12

Ok sorry my fault, i have understand wrong. I have think it's needed a website with playername and stats.

In this kind

Name Max Title

Player Name1 Kind of a Big Deal, Sweet Tooth track
Player Name2 Sweet Tooth track

etc.

A simple counter, is a other thing, okay. you become anyway a message ig, if have change a title to max. so will this easy to count.

Musei Karasu · May 28, 2008, 06:22 PM // 18:22

Code:

for(Player a : listOfPlayers) //let's assume that there's a list of all player accounts, which they should have.
{
     if(hasTitle(KOABD)) //easy to write if they haven't already
           title++;
}
double avg = title/listOfPlayers.size();

That code can easily execute on my computer several thousand times in a second. Let's assume that there's 5million players, since there was recently a thread about how NCSoft has now sold 5million copies of GW. It would take this code less than a minute to execute, and calcuate that for each title. So we can say since there's 36 titles, that it'd likely take 36 minutes or so to compile this little bit of data. Here's the easy part, once you have the list, just do title++ every time someone earns the title. It'll take less than a second. Definately not lag causing.

pOmrAkkUn · May 28, 2008, 06:46 PM // 18:46

that would be nice! I wanna know about top rank PvP titles, who is leading on each title too xD

Alex the Great · May 28, 2008, 06:55 PM // 18:55

Quote:

Originally Posted by Ctb

I hate that game. I never understood what they were telling me to do in the last training exercise so I always got frustrated and shot the CO.

I'm probably not prime military material...

I never finished the training either XD.

The Op's idea is alright, but not really needed.

Sethellington · May 28, 2008, 07:00 PM // 19:00

i like the idea. i like numbers and graphs haha.

mazza558 · May 28, 2008, 07:06 PM // 19:06

/Signed.

I'd love this - it would give everyone an idea of the composition of the playerbase. Is there really an elite minority who browses forums and is very experienced, or is everyone in the game experienced?

Zerdikus · May 28, 2008, 09:15 PM // 21:15

Quote:

Originally Posted by Musei Karasu

Code:

for(Player a : listOfPlayers) //let's assume that there's a list of all player accounts, which they should have.
{
     if(hasTitle(KOABD)) //easy to write if they haven't already
           title++;
}
double avg = title/listOfPlayers.size();

That code can easily execute on my computer several thousand times in a second. Let's assume that there's 5million players, since there was recently a thread about how NCSoft has now sold 5million copies of GW. It would take this code less than a minute to execute, and calcuate that for each title. So we can say since there's 36 titles, that it'd likely take 36 minutes or so to compile this little bit of data. Here's the easy part, once you have the list, just do title++ every time someone earns the title. It'll take less than a second. Definately not lag causing.

it's a bit a difference on the performance between a simple c++ code and c++ code with sql querys,
like this EXEC SQL SELECT...

Nobody has a knowledge about the structure of the used database. maybe she have no table for titles,
maybe she have and this table have follow structure player_id, title_id, title_rang. The kind of the
sql query it's founded on the structure of the database.

If the table has this structure you need a query how read the needed title_id for KOABD in case if title_rang => 5.
If you like it more excat, you need more querys like this ... if title_rang => 5 and title_rang < 10,
title_rang => 10 and title_rang < 15 etc.

Try it and you will it realize. And for the first run you need a sql query, later you can maybe it realize
with a simple counter.

Diddy bow · May 28, 2008, 11:00 PM // 23:00

As cool as it would be i doubt its possible or cost worthly for A-net, we can hope though ^^.